package com.zygh.policeasset.mapper;

import com.zygh.policeasset.pojo.AssetsSystem;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.type.JdbcType;

@Mapper
/* loaded from: police-asset-2.0-0.0.1-SNAPSHOT.jar:BOOT-INF/classes/com/zygh/policeasset/mapper/AssetsSystemMapper.class */
public interface AssetsSystemMapper {
    @Select({"select *  from  assets_system where id = #{id}"})
    @ResultMap({"AssetsSystemMap"})
    AssetsSystem queryById(Integer num);

    @Select({"select *  from assets_system "})
    @Results(id = "AssetsSystemMap", value = {@Result(column = "id", property = "id", jdbcType = JdbcType.INTEGER, id = true), @Result(column = "assets_system_name", property = "assetsSystemName", jdbcType = JdbcType.VARCHAR)})
    List<AssetsSystem> queryAll();

    @Insert({"insert into assets_system (assets_system_name,remark) values(#{AssetsSystemName},#{remark})"})
    @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id")
    int add(AssetsSystem assetsSystem);

    @Update({"update assets_system set assets_system_name = #{AssetsSystemName},remark = #{remark} where id = #{id}"})
    int update(AssetsSystem assetsSystem);

    @Delete({"delete from assets_system where id = #{id}"})
    int deleteById(Integer num);
}